Dataset statistics
| Number of variables | 16 |
|---|---|
| Number of observations | 791 |
| Missing cells | 32 |
| Missing cells (%) | 0.3% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 137.3 KiB |
| Average record size in memory | 177.8 B |
Variable types
| DateTime | 2 |
|---|---|
| Numeric | 9 |
| Categorical | 2 |
| Text | 3 |
date has constant value "" | Constant |
recovered has constant value "" | Constant |
recovered_diff has constant value "" | Constant |
confirmed is highly overall correlated with deaths and 1 other fields | High correlation |
deaths is highly overall correlated with confirmed and 1 other fields | High correlation |
confirmed_diff is highly overall correlated with deaths_diff and 1 other fields | High correlation |
deaths_diff is highly overall correlated with confirmed_diff and 1 other fields | High correlation |
active is highly overall correlated with confirmed and 1 other fields | High correlation |
active_diff is highly overall correlated with confirmed_diff and 1 other fields | High correlation |
lat has 16 (2.0%) missing values | Missing |
long has 16 (2.0%) missing values | Missing |
confirmed has 11 (1.4%) zeros | Zeros |
deaths has 33 (4.2%) zeros | Zeros |
confirmed_diff has 441 (55.8%) zeros | Zeros |
deaths_diff has 630 (79.6%) zeros | Zeros |
active has 8 (1.0%) zeros | Zeros |
active_diff has 436 (55.1%) zeros | Zeros |
fatality_rate has 36 (4.6%) zeros | Zeros |
Reproduction
| Analysis started | 2023-08-04 07:29:00.305107 |
|---|---|
| Analysis finished | 2023-08-04 07:30:47.052658 |
| Duration | 1 minute and 46.75 seconds |
| Software version | ydata-profiling vv4.3.1 |
| Download configuration | config.json |
date
Date
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
| Minimum | 2023-03-09 00:00:00 |
|---|---|
| Maximum | 2023-03-09 00:00:00 |
Histogram with fixed size bins (bins=1)
confirmed
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 780 |
|---|---|
| Distinct (%) | 98.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 855303.15 |
| Minimum | 0 |
|---|---|
| Maximum | 38618509 |
| Zeros | 11 |
| Zeros (%) | 1.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 3464.5 |
| Q1 | 61795.5 |
| median | 211158 |
| Q3 | 673208 |
| 95-th percentile | 3421827.5 |
| Maximum | 38618509 |
| Range | 38618509 |
| Interquartile range (IQR) | 611412.5 |
Descriptive statistics
| Standard deviation | 2397051.2 |
|---|---|
| Coefficient of variation (CV) | 2.802575 |
| Kurtosis | 117.06182 |
| Mean | 855303.15 |
| Median Absolute Deviation (MAD) | 191478 |
| Skewness | 9.2535468 |
| Sum | 6.7654479 × 108 |
| Variance | 5.7458546 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 11 | 1.4% |
| 13 | 2 | 0.3% |
| 209451 | 1 | 0.1% |
| 103374 | 1 | 0.1% |
| 356814 | 1 | 0.1% |
| 168582 | 1 | 0.1% |
| 188152 | 1 | 0.1% |
| 155600 | 1 | 0.1% |
| 47057 | 1 | 0.1% |
| 404282 | 1 | 0.1% |
| Other values (770) | 770 |
| Value | Count | Frequency (%) |
| 0 | 11 | |
| 4 | 1 | 0.1% |
| 9 | 1 | 0.1% |
| 13 | 2 | 0.3% |
| 29 | 1 | 0.1% |
| 42 | 1 | 0.1% |
| 49 | 1 | 0.1% |
| 103 | 1 | 0.1% |
| 173 | 1 | 0.1% |
| 712 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 38618509 | 1 | |
| 30615522 | 1 | |
| 20656177 | 1 | |
| 17042722 | 1 | |
| 12129699 | 1 | |
| 11526994 | 1 | |
| 10044957 | 1 | |
| 9970937 | 1 | |
| 8466220 | 1 | |
| 8138129 | 1 |
deaths
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 706 |
|---|---|
| Distinct (%) | 89.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8700.0468 |
| Minimum | 0 |
|---|---|
| Maximum | 186138 |
| Zeros | 33 |
| Zeros (%) | 4.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 534.5 |
| median | 2548 |
| Q3 | 8297 |
| 95-th percentile | 36014.5 |
| Maximum | 186138 |
| Range | 186138 |
| Interquartile range (IQR) | 7762.5 |
Descriptive statistics
| Standard deviation | 19993.092 |
|---|---|
| Coefficient of variation (CV) | 2.2980441 |
| Kurtosis | 33.23648 |
| Mean | 8700.0468 |
| Median Absolute Deviation (MAD) | 2410 |
| Skewness | 5.2307259 |
| Sum | 6881737 |
| Variance | 3.9972371 × 108 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 33 | 4.2% |
| 2 | 11 | 1.4% |
| 1 | 5 | 0.6% |
| 7 | 4 | 0.5% |
| 4 | 3 | 0.4% |
| 834 | 3 | 0.4% |
| 3 | 3 | 0.4% |
| 1031 | 2 | 0.3% |
| 225 | 2 | 0.3% |
| 38 | 2 | 0.3% |
| Other values (696) | 723 |
| Value | Count | Frequency (%) |
| 0 | 33 | |
| 1 | 5 | 0.6% |
| 2 | 11 | 1.4% |
| 3 | 3 | 0.4% |
| 4 | 3 | 0.4% |
| 5 | 2 | 0.3% |
| 6 | 2 | 0.3% |
| 7 | 4 | 0.5% |
| 8 | 2 | 0.3% |
| 9 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 186138 | 1 | |
| 179039 | 1 | |
| 161512 | 1 | |
| 160941 | 1 | |
| 148424 | 1 | |
| 144933 | 1 | |
| 130472 | 1 | |
| 119010 | 1 | |
| 102595 | 1 | |
| 101492 | 1 |
recovered
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 791 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 791 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 791 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 791 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 791 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 791 |
confirmed_diff
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 227 |
|---|---|
| Distinct (%) | 28.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 245.38685 |
| Minimum | 0 |
|---|---|
| Maximum | 26285 |
| Zeros | 441 |
| Zeros (%) | 55.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 89 |
| 95-th percentile | 739.5 |
| Maximum | 26285 |
| Range | 26285 |
| Interquartile range (IQR) | 89 |
Descriptive statistics
| Standard deviation | 1412.1194 |
|---|---|
| Coefficient of variation (CV) | 5.7546662 |
| Kurtosis | 197.62264 |
| Mean | 245.38685 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.760423 |
| Sum | 194101 |
| Variance | 1994081.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 441 | |
| 1 | 12 | 1.5% |
| 14 | 8 | 1.0% |
| 3 | 7 | 0.9% |
| 11 | 6 | 0.8% |
| 4 | 6 | 0.8% |
| 2 | 5 | 0.6% |
| 90 | 5 | 0.6% |
| 9 | 5 | 0.6% |
| 8 | 5 | 0.6% |
| Other values (217) | 291 |
| Value | Count | Frequency (%) |
| 0 | 441 | |
| 1 | 12 | 1.5% |
| 2 | 5 | 0.6% |
| 3 | 7 | 0.9% |
| 4 | 6 | 0.8% |
| 5 | 2 | 0.3% |
| 6 | 3 | 0.4% |
| 7 | 4 | 0.5% |
| 8 | 5 | 0.6% |
| 9 | 5 | 0.6% |
| Value | Count | Frequency (%) |
| 26285 | 1 | |
| 19402 | 1 | |
| 10335 | 1 | |
| 10320 | 1 | |
| 8332 | 1 | |
| 7863 | 1 | |
| 6308 | 1 | |
| 5283 | 1 | |
| 3602 | 1 | |
| 3551 | 1 |
deaths_diff
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 34 |
|---|---|
| Distinct (%) | 4.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.3438685 |
| Minimum | -1 |
|---|---|
| Maximum | 431 |
| Zeros | 630 |
| Zeros (%) | 79.6% |
| Negative | 1 |
| Negative (%) | 0.1% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | -1 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 8 |
| Maximum | 431 |
| Range | 432 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 18.059342 |
|---|---|
| Coefficient of variation (CV) | 7.7049296 |
| Kurtosis | 422.99695 |
| Mean | 2.3438685 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 19.05543 |
| Sum | 1854 |
| Variance | 326.13983 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=34)
| Value | Count | Frequency (%) |
| 0 | 630 | |
| 1 | 49 | 6.2% |
| 2 | 22 | 2.8% |
| 3 | 17 | 2.1% |
| 4 | 16 | 2.0% |
| 5 | 10 | 1.3% |
| 11 | 6 | 0.8% |
| 9 | 4 | 0.5% |
| 7 | 3 | 0.4% |
| 8 | 3 | 0.4% |
| Other values (24) | 31 | 3.9% |
| Value | Count | Frequency (%) |
| -1 | 1 | 0.1% |
| 0 | 630 | |
| 1 | 49 | 6.2% |
| 2 | 22 | 2.8% |
| 3 | 17 | 2.1% |
| 4 | 16 | 2.0% |
| 5 | 10 | 1.3% |
| 6 | 2 | 0.3% |
| 7 | 3 | 0.4% |
| 8 | 3 | 0.4% |
| Value | Count | Frequency (%) |
| 431 | 1 | |
| 205 | 1 | |
| 84 | 1 | |
| 53 | 1 | |
| 50 | 1 | |
| 48 | 1 | |
| 47 | 1 | |
| 43 | 1 | |
| 42 | 1 | |
| 39 | 1 |
recovered_diff
Categorical
CONSTANT
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
| 0 |
|---|
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 791 |
|---|---|
| Distinct characters | 1 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0 |
|---|---|
| 2nd row | 0 |
| 3rd row | 0 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 791 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 791 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 791 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 0 | 791 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 791 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 0 | 791 |
last_update
Date
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
| Minimum | 2020-08-04 02:27:56 |
|---|---|
| Maximum | 2023-03-10 04:21:03 |
Histogram with fixed size bins (bins=5)
active
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 783 |
|---|---|
| Distinct (%) | 99.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 846603.1 |
| Minimum | -338 |
|---|---|
| Maximum | 38456997 |
| Zeros | 8 |
| Zeros (%) | 1.0% |
| Negative | 3 |
| Negative (%) | 0.4% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | -338 |
|---|---|
| 5-th percentile | 3420.5 |
| Q1 | 58984.5 |
| median | 207505 |
| Q3 | 667300 |
| 95-th percentile | 3393526.5 |
| Maximum | 38456997 |
| Range | 38457335 |
| Interquartile range (IQR) | 608315.5 |
Descriptive statistics
| Standard deviation | 2382864.6 |
|---|---|
| Coefficient of variation (CV) | 2.8146184 |
| Kurtosis | 118.17952 |
| Mean | 846603.1 |
| Median Absolute Deviation (MAD) | 188500 |
| Skewness | 9.3049556 |
| Sum | 6.6966305 × 108 |
| Variance | 5.6780438 × 1012 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 8 | 1.0% |
| 13 | 2 | 0.3% |
| 201555 | 1 | 0.1% |
| 131543 | 1 | 0.1% |
| 166246 | 1 | 0.1% |
| 184006 | 1 | 0.1% |
| 152476 | 1 | 0.1% |
| 45981 | 1 | 0.1% |
| 396005 | 1 | 0.1% |
| 7412 | 1 | 0.1% |
| Other values (773) | 773 |
| Value | Count | Frequency (%) |
| -338 | 1 | 0.1% |
| -2 | 1 | 0.1% |
| -1 | 1 | 0.1% |
| 0 | 8 | |
| 4 | 1 | 0.1% |
| 7 | 1 | 0.1% |
| 13 | 2 | 0.3% |
| 29 | 1 | 0.1% |
| 40 | 1 | 0.1% |
| 49 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 38456997 | 1 | |
| 30581429 | 1 | |
| 20470039 | 1 | |
| 16941230 | 1 | |
| 12028540 | 1 | |
| 11483808 | 1 | |
| 9953265 | 1 | |
| 9914485 | 1 | |
| 8372830 | 1 | |
| 8016996 | 1 |
active_diff
Real number (ℝ)
HIGH CORRELATION ZEROS
| Distinct | 232 |
|---|---|
| Distinct (%) | 29.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 243.04298 |
| Minimum | -13 |
|---|---|
| Maximum | 25854 |
| Zeros | 436 |
| Zeros (%) | 55.1% |
| Negative | 4 |
| Negative (%) | 0.5% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | -13 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 88.5 |
| 95-th percentile | 727 |
| Maximum | 25854 |
| Range | 25867 |
| Interquartile range (IQR) | 88.5 |
Descriptive statistics
| Standard deviation | 1396.168 |
|---|---|
| Coefficient of variation (CV) | 5.7445314 |
| Kurtosis | 195.00238 |
| Mean | 243.04298 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 12.679607 |
| Sum | 192247 |
| Variance | 1949285.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 436 | |
| 1 | 13 | 1.6% |
| 3 | 7 | 0.9% |
| 14 | 7 | 0.9% |
| 4 | 6 | 0.8% |
| 11 | 6 | 0.8% |
| 8 | 5 | 0.6% |
| 2 | 5 | 0.6% |
| 20 | 5 | 0.6% |
| 9 | 5 | 0.6% |
| Other values (222) | 296 |
| Value | Count | Frequency (%) |
| -13 | 1 | 0.1% |
| -5 | 1 | 0.1% |
| -1 | 2 | 0.3% |
| 0 | 436 | |
| 1 | 13 | 1.6% |
| 2 | 5 | 0.6% |
| 3 | 7 | 0.9% |
| 4 | 6 | 0.8% |
| 5 | 2 | 0.3% |
| 6 | 4 | 0.5% |
| Value | Count | Frequency (%) |
| 25854 | 1 | |
| 19197 | 1 | |
| 10323 | 1 | |
| 10267 | 1 | |
| 8285 | 1 | |
| 7827 | 1 | |
| 6297 | 1 | |
| 5262 | 1 | |
| 3552 | 1 | |
| 3519 | 1 |
fatality_rate
Real number (ℝ)
ZEROS
| Distinct | 323 |
|---|---|
| Distinct (%) | 40.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.015246397 |
| Minimum | 0 |
|---|---|
| Maximum | 0.5336 |
| Zeros | 36 |
| Zeros (%) | 4.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0.0001 |
| Q1 | 0.0043 |
| median | 0.0103 |
| Q3 | 0.0191 |
| 95-th percentile | 0.04625 |
| Maximum | 0.5336 |
| Range | 0.5336 |
| Interquartile range (IQR) | 0.0148 |
Descriptive statistics
| Standard deviation | 0.025190417 |
|---|---|
| Coefficient of variation (CV) | 1.652221 |
| Kurtosis | 234.56428 |
| Mean | 0.015246397 |
| Median Absolute Deviation (MAD) | 0.0071 |
| Skewness | 12.432413 |
| Sum | 12.0599 |
| Variance | 0.0006345571 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 36 | 4.6% |
| 0.002 | 8 | 1.0% |
| 0.0018 | 8 | 1.0% |
| 0.0024 | 8 | 1.0% |
| 0.0001 | 7 | 0.9% |
| 0.0039 | 7 | 0.9% |
| 0.0019 | 7 | 0.9% |
| 0.0101 | 7 | 0.9% |
| 0.0079 | 7 | 0.9% |
| 0.0017 | 7 | 0.9% |
| Other values (313) | 689 |
| Value | Count | Frequency (%) |
| 0 | 36 | |
| 0.0001 | 7 | 0.9% |
| 0.0002 | 1 | 0.1% |
| 0.0003 | 3 | 0.4% |
| 0.0004 | 2 | 0.3% |
| 0.0005 | 2 | 0.3% |
| 0.0006 | 4 | 0.5% |
| 0.0007 | 5 | 0.6% |
| 0.0008 | 6 | 0.8% |
| 0.0009 | 2 | 0.3% |
| Value | Count | Frequency (%) |
| 0.5336 | 1 | |
| 0.2222 | 1 | |
| 0.1807 | 1 | |
| 0.0786 | 1 | |
| 0.078 | 1 | |
| 0.0757 | 1 | |
| 0.073 | 1 | |
| 0.0729 | 1 | |
| 0.0728 | 1 | |
| 0.072 | 1 |
iso
Text
| Distinct | 196 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 3 |
| Mean length | 3.0189633 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2388 |
|---|---|
| Distinct characters | 27 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 171 ? |
|---|---|
| Unique (%) | 21.6% |
Sample
| 1st row | AFG |
|---|---|
| 2nd row | ALB |
| 3rd row | DZA |
| 4th row | AND |
| 5th row | AGO |
| Value | Count | Frequency (%) |
| rus | 83 | 10.5% |
| usa | 59 | 7.5% |
| jpn | 49 | 6.2% |
| ind | 37 | 4.7% |
| col | 34 | 4.3% |
| chn | 34 | 4.3% |
| mex | 33 | 4.2% |
| ukr | 28 | 3.5% |
| bra | 27 | 3.4% |
| per | 26 | 3.3% |
| Other values (186) | 381 |
Most occurring characters
| Value | Count | Frequency (%) |
| S | 240 | 10.1% |
| R | 234 | 9.8% |
| U | 214 | 9.0% |
| N | 196 | 8.2% |
| A | 189 | 7.9% |
| E | 150 | 6.3% |
| C | 121 | 5.1% |
| P | 118 | 4.9% |
| L | 111 | 4.6% |
| D | 93 | 3.9% |
| Other values (17) | 722 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 2384 | |
| Dash Punctuation | 4 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 240 | 10.1% |
| R | 234 | 9.8% |
| U | 214 | 9.0% |
| N | 196 | 8.2% |
| A | 189 | 7.9% |
| E | 150 | 6.3% |
| C | 121 | 5.1% |
| P | 118 | 4.9% |
| L | 111 | 4.7% |
| D | 93 | 3.9% |
| Other values (16) | 718 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 4 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2384 | |
| Common | 4 | 0.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| S | 240 | 10.1% |
| R | 234 | 9.8% |
| U | 214 | 9.0% |
| N | 196 | 8.2% |
| A | 189 | 7.9% |
| E | 150 | 6.3% |
| C | 121 | 5.1% |
| P | 118 | 4.9% |
| L | 111 | 4.7% |
| D | 93 | 3.9% |
| Other values (16) | 718 |
Common
| Value | Count | Frequency (%) |
| - | 4 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2388 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| S | 240 | 10.1% |
| R | 234 | 9.8% |
| U | 214 | 9.0% |
| N | 196 | 8.2% |
| A | 189 | 7.9% |
| E | 150 | 6.3% |
| C | 121 | 5.1% |
| P | 118 | 4.9% |
| L | 111 | 4.6% |
| D | 93 | 3.9% |
| Other values (17) | 722 |
name
Text
| Distinct | 196 |
|---|---|
| Distinct (%) | 24.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
Length
| Max length | 32 |
|---|---|
| Median length | 24 |
| Mean length | 6.5613148 |
| Min length | 2 |
Characters and Unicode
| Total characters | 5190 |
|---|---|
| Distinct characters | 58 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 171 ? |
|---|---|
| Unique (%) | 21.6% |
Sample
| 1st row | Afghanistan |
|---|---|
| 2nd row | Albania |
| 3rd row | Algeria |
| 4th row | Andorra |
| 5th row | Angola |
| Value | Count | Frequency (%) |
| russia | 83 | 9.6% |
| us | 59 | 6.9% |
| japan | 49 | 5.7% |
| india | 37 | 4.3% |
| colombia | 34 | 3.9% |
| china | 34 | 3.9% |
| mexico | 33 | 3.8% |
| ukraine | 28 | 3.3% |
| brazil | 27 | 3.1% |
| peru | 26 | 3.0% |
| Other values (218) | 451 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 801 | |
| i | 525 | 10.1% |
| n | 420 | 8.1% |
| e | 342 | 6.6% |
| s | 263 | 5.1% |
| r | 219 | 4.2% |
| o | 206 | 4.0% |
| l | 204 | 3.9% |
| u | 188 | 3.6% |
| d | 177 | 3.4% |
| Other values (48) | 1845 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 4196 | |
| Uppercase Letter | 915 | 17.6% |
| Space Separator | 70 | 1.3% |
| Other Punctuation | 3 | 0.1% |
| Dash Punctuation | 2 | < 0.1% |
| Close Punctuation | 2 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 801 | |
| i | 525 | |
| n | 420 | |
| e | 342 | |
| s | 263 | 6.3% |
| r | 219 | 5.2% |
| o | 206 | 4.9% |
| l | 204 | 4.9% |
| u | 188 | 4.5% |
| d | 177 | 4.2% |
| Other values (16) | 851 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 128 | |
| C | 115 | |
| U | 110 | |
| R | 88 | |
| M | 67 | |
| I | 67 | |
| B | 59 | 6.4% |
| J | 51 | 5.6% |
| P | 42 | 4.6% |
| G | 31 | 3.4% |
| Other values (15) | 157 |
Other Punctuation
| Value | Count | Frequency (%) |
| ' | 1 | |
| * | 1 | |
| , | 1 |
Space Separator
| Value | Count | Frequency (%) |
| 70 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 2 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 5111 | |
| Common | 79 | 1.5% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 801 | |
| i | 525 | 10.3% |
| n | 420 | 8.2% |
| e | 342 | 6.7% |
| s | 263 | 5.1% |
| r | 219 | 4.3% |
| o | 206 | 4.0% |
| l | 204 | 4.0% |
| u | 188 | 3.7% |
| d | 177 | 3.5% |
| Other values (41) | 1766 |
Common
| Value | Count | Frequency (%) |
| 70 | ||
| - | 2 | 2.5% |
| ) | 2 | 2.5% |
| ( | 2 | 2.5% |
| ' | 1 | 1.3% |
| * | 1 | 1.3% |
| , | 1 | 1.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5190 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 801 | |
| i | 525 | 10.1% |
| n | 420 | 8.1% |
| e | 342 | 6.6% |
| s | 263 | 5.1% |
| r | 219 | 4.2% |
| o | 206 | 4.0% |
| l | 204 | 3.9% |
| u | 188 | 3.6% |
| d | 177 | 3.4% |
| Other values (48) | 1845 |
province
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 75.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.6 KiB |
Length
| Max length | 44 |
|---|---|
| Median length | 31 |
| Mean length | 8.1441214 |
| Min length | 0 |
Characters and Unicode
| Total characters | 6442 |
|---|---|
| Distinct characters | 60 |
| Distinct categories | 7 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 592 ? |
|---|---|
| Unique (%) | 74.8% |
Sample
| 1st row | |
|---|---|
| 2nd row | |
| 3rd row | |
| 4th row | |
| 5th row |
| Value | Count | Frequency (%) |
| oblast | 70 | 7.8% |
| republic | 22 | 2.4% |
| unknown | 14 | 1.6% |
| and | 12 | 1.3% |
| islands | 11 | 1.2% |
| krai | 9 | 1.0% |
| new | 7 | 0.8% |
| pradesh | 5 | 0.6% |
| okrug | 5 | 0.6% |
| autonomous | 5 | 0.6% |
| Other values (662) | 742 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 920 | 14.3% |
| n | 446 | 6.9% |
| i | 422 | 6.6% |
| r | 357 | 5.5% |
| o | 352 | 5.5% |
| e | 343 | 5.3% |
| s | 335 | 5.2% |
| l | 312 | 4.8% |
| t | 290 | 4.5% |
| 285 | 4.4% | |
| Other values (50) | 2380 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5223 | |
| Uppercase Letter | 896 | 13.9% |
| Space Separator | 285 | 4.4% |
| Dash Punctuation | 18 | 0.3% |
| Other Punctuation | 16 | 0.2% |
| Close Punctuation | 2 | < 0.1% |
| Open Punctuation | 2 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 920 | |
| n | 446 | 8.5% |
| i | 422 | 8.1% |
| r | 357 | 6.8% |
| o | 352 | 6.7% |
| e | 343 | 6.6% |
| s | 335 | 6.4% |
| l | 312 | 6.0% |
| t | 290 | 5.6% |
| u | 222 | 4.3% |
| Other values (16) | 1224 |
Uppercase Letter
| Value | Count | Frequency (%) |
| O | 94 | 10.5% |
| S | 65 | 7.3% |
| A | 62 | 6.9% |
| M | 61 | 6.8% |
| C | 61 | 6.8% |
| P | 55 | 6.1% |
| K | 52 | 5.8% |
| N | 49 | 5.5% |
| R | 42 | 4.7% |
| T | 39 | 4.4% |
| Other values (16) | 316 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 11 | |
| * | 2 | 12.5% |
| , | 2 | 12.5% |
| ' | 1 | 6.2% |
Space Separator
| Value | Count | Frequency (%) |
| 285 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 18 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6119 | |
| Common | 323 | 5.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 920 | |
| n | 446 | 7.3% |
| i | 422 | 6.9% |
| r | 357 | 5.8% |
| o | 352 | 5.8% |
| e | 343 | 5.6% |
| s | 335 | 5.5% |
| l | 312 | 5.1% |
| t | 290 | 4.7% |
| u | 222 | 3.6% |
| Other values (42) | 2120 |
Common
| Value | Count | Frequency (%) |
| 285 | ||
| - | 18 | 5.6% |
| . | 11 | 3.4% |
| * | 2 | 0.6% |
| , | 2 | 0.6% |
| ) | 2 | 0.6% |
| ( | 2 | 0.6% |
| ' | 1 | 0.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6442 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 920 | 14.3% |
| n | 446 | 6.9% |
| i | 422 | 6.6% |
| r | 357 | 5.5% |
| o | 352 | 5.5% |
| e | 343 | 5.3% |
| s | 335 | 5.2% |
| l | 312 | 4.8% |
| t | 290 | 4.5% |
| 285 | 4.4% | |
| Other values (50) | 2380 |
lat
Real number (ℝ)
MISSING
| Distinct | 769 |
|---|---|
| Distinct (%) | 99.2% |
| Missing | 16 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.682965 |
| Minimum | -52.368 |
|---|---|
| Maximum | 71.7069 |
| Zeros | 4 |
| Zeros (%) | 0.5% |
| Negative | 125 |
| Negative (%) | 15.8% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | -52.368 |
|---|---|
| 5-th percentile | -21.14827 |
| Q1 | 8.64495 |
| median | 33.75943 |
| Q3 | 47.176909 |
| 95-th percentile | 58.595202 |
| Maximum | 71.7069 |
| Range | 124.0749 |
| Interquartile range (IQR) | 38.531959 |
Descriptive statistics
| Standard deviation | 25.591264 |
|---|---|
| Coefficient of variation (CV) | 0.95908622 |
| Kurtosis | -0.22957951 |
| Mean | 26.682965 |
| Median Absolute Deviation (MAD) | 17.21447 |
| Skewness | -0.7122306 |
| Sum | 20679.298 |
| Variance | 654.91279 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4 | 0.5% |
| 52.9399 | 2 | 0.3% |
| 37.6489 | 2 | 0.3% |
| 13.1939 | 2 | 0.3% |
| 48.57527615 | 1 | 0.1% |
| 54.4223954 | 1 | 0.1% |
| 66.0006475 | 1 | 0.1% |
| 55.4259922 | 1 | 0.1% |
| 43.0574916 | 1 | 0.1% |
| 43.11542075 | 1 | 0.1% |
| Other values (759) | 759 | |
| (Missing) | 16 | 2.0% |
| Value | Count | Frequency (%) |
| -52.368 | 1 | |
| -51.7963 | 1 | |
| -48.4674 | 1 | |
| -45.9864 | 1 | |
| -41.9198 | 1 | |
| -41.4545 | 1 | |
| -40.9006 | 1 | |
| -40.231 | 1 | |
| -38.9489 | 1 | |
| -38.4161 | 1 |
| Value | Count | Frequency (%) |
| 71.7069 | 1 | |
| 70.2998 | 1 | |
| 68.27557185 | 1 | |
| 68.0000418 | 1 | |
| 67.1471631 | 1 | |
| 66.941626 | 1 | |
| 66.8309 | 1 | |
| 66.0006475 | 1 | |
| 65.3337 | 1 | |
| 64.9631 | 1 |
long
Real number (ℝ)
MISSING
| Distinct | 759 |
|---|---|
| Distinct (%) | 97.9% |
| Missing | 16 |
| Missing (%) | 2.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 11.409754 |
| Minimum | -178.1165 |
|---|---|
| Maximum | 178.065 |
| Zeros | 4 |
| Zeros (%) | 0.5% |
| Negative | 299 |
| Negative (%) | 37.8% |
| Memory size | 44.6 KiB |
Quantile statistics
| Minimum | -178.1165 |
|---|---|
| 5-th percentile | -102.37908 |
| Q1 | -68.3816 |
| median | 14.3754 |
| Q3 | 73.10106 |
| 95-th percentile | 138.1542 |
| Maximum | 178.065 |
| Range | 356.1815 |
| Interquartile range (IQR) | 141.48266 |
Descriptive statistics
| Standard deviation | 78.510938 |
|---|---|
| Coefficient of variation (CV) | 6.8810367 |
| Kurtosis | -0.89007244 |
| Mean | 11.409754 |
| Median Absolute Deviation (MAD) | 71.22944 |
| Skewness | 0.010818123 |
| Sum | 8842.5596 |
| Variance | 6163.9674 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 4 | 0.5% |
| -36.9541 | 2 | 0.3% |
| -72.1416 | 2 | 0.3% |
| -59.5432 | 2 | 0.3% |
| -71.5724 | 2 | 0.3% |
| -70.812 | 2 | 0.3% |
| -36.782 | 2 | 0.3% |
| -74.03 | 2 | 0.3% |
| -72.3311 | 2 | 0.3% |
| -122.6655 | 2 | 0.3% |
| Other values (749) | 753 | |
| (Missing) | 16 | 2.0% |
| Value | Count | Frequency (%) |
| -178.1165 | 1 | |
| -175.1982 | 1 | |
| -172.1046 | 1 | |
| -170.132 | 1 | |
| -169.8672 | 1 | |
| -168.734 | 1 | |
| -159.7777 | 1 | |
| -157.4983 | 1 | |
| -152.4044 | 1 | |
| -149.4068 | 1 |
| Value | Count | Frequency (%) |
| 178.065 | 1 | |
| 177.6493 | 1 | |
| 174.886 | 1 | |
| 171.1845 | 1 | |
| 169.4900869 | 1 | |
| 166.9592 | 1 | |
| 166.9315 | 1 | |
| 165.618 | 1 | |
| 160.1562 | 1 | |
| 160.0383819 | 1 |
| confirmed | deaths | confirmed_diff | deaths_diff | active | active_diff | fatality_rate | lat | long | |
|---|---|---|---|---|---|---|---|---|---|
| confirmed | 1.000 | 0.821 | 0.354 | 0.361 | 1.000 | 0.344 | 0.013 | 0.091 | 0.112 |
| deaths | 0.821 | 1.000 | 0.224 | 0.290 | 0.816 | 0.217 | 0.493 | -0.001 | -0.001 |
| confirmed_diff | 0.354 | 0.224 | 1.000 | 0.666 | 0.353 | 0.996 | -0.034 | 0.227 | 0.203 |
| deaths_diff | 0.361 | 0.290 | 0.666 | 1.000 | 0.360 | 0.645 | -0.051 | 0.111 | -0.002 |
| active | 1.000 | 0.816 | 0.353 | 0.360 | 1.000 | 0.343 | 0.007 | 0.093 | 0.114 |
| active_diff | 0.344 | 0.217 | 0.996 | 0.645 | 0.343 | 1.000 | -0.033 | 0.222 | 0.202 |
| fatality_rate | 0.013 | 0.493 | -0.034 | -0.051 | 0.007 | -0.033 | 1.000 | -0.109 | -0.089 |
| lat | 0.091 | -0.001 | 0.227 | 0.111 | 0.093 | 0.222 | -0.109 | 1.000 | 0.302 |
| long | 0.112 | -0.001 | 0.203 | -0.002 | 0.114 | 0.202 | -0.089 | 0.302 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| date | confirmed | deaths | recovered | confirmed_diff | deaths_diff | recovered_diff | last_update | active | active_diff | fatality_rate | iso | name | province | lat | long | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| df_index | ||||||||||||||||
| 0 | 2023-03-09 | 209451 | 7896 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 201555 | 0 | 0.0377 | AFG | Afghanistan | 33.9391 | 67.7100 | |
| 1 | 2023-03-09 | 334457 | 3598 | 0 | 14 | 0 | 0 | 2023-03-10 04:21:03 | 330859 | 14 | 0.0108 | ALB | Albania | 41.1533 | 20.1683 | |
| 2 | 2023-03-09 | 271496 | 6881 | 0 | 2 | 0 | 0 | 2023-03-10 04:21:03 | 264615 | 2 | 0.0253 | DZA | Algeria | 28.0339 | 1.6596 | |
| 3 | 2023-03-09 | 47890 | 165 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 47725 | 0 | 0.0034 | AND | Andorra | 42.5063 | 1.5218 | |
| 4 | 2023-03-09 | 105288 | 1933 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 103355 | 0 | 0.0184 | AGO | Angola | -11.2027 | 17.8739 | |
| 5 | 2023-03-09 | 9106 | 146 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 8960 | 0 | 0.0160 | ATG | Antigua and Barbuda | 17.0608 | -61.7964 | |
| 6 | 2023-03-09 | 10044957 | 130472 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 9914485 | 0 | 0.0130 | ARG | Argentina | -38.4161 | -63.6167 | |
| 7 | 2023-03-09 | 447308 | 8727 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 438581 | 0 | 0.0195 | ARM | Armenia | 40.0691 | 45.0382 | |
| 8 | 2023-03-09 | 232974 | 228 | 0 | 355 | 0 | 0 | 2023-03-10 04:21:03 | 232746 | 355 | 0.0010 | AUS | Australia | Australian Capital Territory | -35.4735 | 149.0124 |
| 9 | 2023-03-09 | 3915992 | 6529 | 0 | 7863 | 36 | 0 | 2023-03-10 04:21:03 | 3909463 | 7827 | 0.0017 | AUS | Australia | New South Wales | -33.8688 | 151.2093 |
| date | confirmed | deaths | recovered | confirmed_diff | deaths_diff | recovered_diff | last_update | active | active_diff | fatality_rate | iso | name | province | lat | long | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| df_index | ||||||||||||||||
| 781 | 2023-03-09 | 898118 | 11500 | 0 | 577 | 14 | 0 | 2023-03-10 04:21:03 | 886618 | 563 | 0.0128 | GBR | United Kingdom | Wales | 52.1307 | -3.7837 |
| 782 | 2023-03-09 | 1034303 | 7617 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 1026686 | 0 | 0.0074 | URY | Uruguay | -32.5228 | -55.7658 | |
| 783 | 2023-03-09 | 251247 | 1637 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 249610 | 0 | 0.0065 | UZB | Uzbekistan | 41.3775 | 64.5853 | |
| 784 | 2023-03-09 | 12014 | 14 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 12000 | 0 | 0.0012 | VUT | Vanuatu | -15.3767 | 166.9592 | |
| 785 | 2023-03-09 | 552162 | 5854 | 0 | 5 | 0 | 0 | 2023-03-10 04:21:03 | 546308 | 5 | 0.0106 | VEN | Venezuela | 6.4238 | -66.5897 | |
| 786 | 2023-03-09 | 11526994 | 43186 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 11483808 | 0 | 0.0037 | VNM | Vietnam | 14.0583 | 108.2772 | |
| 787 | 2023-03-09 | 703228 | 5708 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 697520 | 0 | 0.0081 | PSE | West Bank and Gaza | 31.9522 | 35.2332 | |
| 788 | 2023-03-09 | 11945 | 2159 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 9786 | 0 | 0.1807 | YEM | Yemen | 15.552726999999999 | 48.516388 | |
| 789 | 2023-03-09 | 343135 | 4057 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 339078 | 0 | 0.0118 | ZMB | Zambia | -13.1339 | 27.8493 | |
| 790 | 2023-03-09 | 264276 | 5671 | 0 | 0 | 0 | 0 | 2023-03-10 04:21:03 | 258605 | 0 | 0.0215 | ZWE | Zimbabwe | -19.0154 | 29.1549 |